﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="SqliteDataManager" targetNamespace="http://tempuri.org/SqliteDataManager.xsd" xmlns:mstns="http://tempuri.org/SqliteDataManager.xsd" xmlns="http://tempuri.org/SqliteDataManager.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="SqliteNetConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="SqliteNetConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.SqliteDataAccess.Properties.Settings.GlobalReference.Default.SqliteNetConnectionString" Provider="System.Data.SQLite" />
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="lppbop_sqliteConnectionString" IsAppSettingsProperty="true" Modifier="Assembly" Name="lppbop_sqliteConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.SqliteDataAccess.Properties.Settings.GlobalReference.Default.lppbop_sqliteConnectionString" Provider="System.Data.SQLite" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="BukuKasUmumTableAdapter" GeneratorDataComponentClassName="BukuKasUmumTableAdapter" Name="BukuKasUmum" UserDataComponentName="BukuKasUmumTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SqliteNetConnectionString (Settings)" DbObjectName="main.buku_kas_umum" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [main].[sqlite_default_schema].[buku_kas_umum] WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [main].[sqlite_default_schema].[buku_kas_umum] ([parent_id], [bulan], [tahun], [kode], [no], [tanggal], [uraian], [penerimaan], [pengeluaran], [sort_order]) VALUES (@parent_id, @bulan, @tahun, @kode, @no, @tanggal, @uraian, @penerimaan, @pengeluaran, @sort_order)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@parent_id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="parent_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@bulan" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="bulan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@tahun" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="tahun" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@kode" Precision="0" ProviderType="AnsiString" Scale="0" Size="0" SourceColumn="kode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@no" Precision="0" ProviderType="AnsiString" Scale="0" Size="0" SourceColumn="no" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@tanggal" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="tanggal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@uraian" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="uraian" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@penerimaan" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="penerimaan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@pengeluaran" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="pengeluaran" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@sort_order" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="sort_order" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        id, parent_id, bulan, tahun, kode, no, tanggal, uraian, penerimaan, pengeluaran, sort_order
FROM            buku_kas_umum
WHERE        (bulan = @bulan) AND (tahun = @tahun)
ORDER BY    sort_order, id</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="bulan" ColumnName="bulan" DataSourceName="main.buku_kas_umum" DataTypeServer="integer(8)" DbType="Int64" Direction="Input" ParameterName="@bulan" Precision="0" ProviderType="Int64" Scale="0" Size="8" SourceColumn="bulan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="tahun" ColumnName="tahun" DataSourceName="main.buku_kas_umum" DataTypeServer="integer(8)" DbType="Int64" Direction="Input" ParameterName="@tahun" Precision="0" ProviderType="Int64" Scale="0" Size="8" SourceColumn="tahun" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [main].[sqlite_default_schema].[buku_kas_umum] SET [parent_id] = @parent_id, [bulan] = @bulan, [tahun] = @tahun, [kode] = @kode, [no] = @no, [tanggal] = @tanggal, [uraian] = @uraian, [penerimaan] = @penerimaan, [pengeluaran] = @pengeluaran, [sort_order] = @sort_order WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@parent_id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="parent_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@bulan" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="bulan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@tahun" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="tahun" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@kode" Precision="0" ProviderType="AnsiString" Scale="0" Size="0" SourceColumn="kode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@no" Precision="0" ProviderType="AnsiString" Scale="0" Size="0" SourceColumn="no" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@tanggal" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="tanggal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@uraian" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="uraian" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@penerimaan" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="penerimaan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@pengeluaran" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="pengeluaran" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@sort_order" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="sort_order" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="bulan" DataSetColumn="bulan" />
              <Mapping SourceColumn="tahun" DataSetColumn="tahun" />
              <Mapping SourceColumn="no" DataSetColumn="no" />
              <Mapping SourceColumn="tanggal" DataSetColumn="tanggal" />
              <Mapping SourceColumn="uraian" DataSetColumn="uraian" />
              <Mapping SourceColumn="penerimaan" DataSetColumn="penerimaan" />
              <Mapping SourceColumn="pengeluaran" DataSetColumn="pengeluaran" />
              <Mapping SourceColumn="sort_order" DataSetColumn="sort_order" />
              <Mapping SourceColumn="kode" DataSetColumn="kode" />
              <Mapping SourceColumn="parent_id" DataSetColumn="parent_id" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="SqliteNetConnectionString (Settings)" DbObjectName="main.buku_kas_umum" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByBulan" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByBulan" GeneratorSourceName="FillByBulan" GetMethodModifier="Public" GetMethodName="GetDataByBulan" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByBulan" UserSourceName="FillByBulan">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT bulan, id, kode, no, parent_id, penerimaan, pengeluaran, sort_order, tahun, tanggal, uraian FROM buku_kas_umum WHERE (bulan IN (@bulan1, @bulan2, @bulan3)) AND (tahun = @tahun)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="bulan1" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="Int32" Direction="Input" ParameterName="@bulan1" Precision="0" Scale="0" Size="0" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="bulan2" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="Int32" Direction="Input" ParameterName="@bulan2" Precision="0" Scale="0" Size="0" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="bulan3" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="Int32" Direction="Input" ParameterName="@bulan3" Precision="0" Scale="0" Size="0" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="tahun" ColumnName="tahun" DataSourceName="main.buku_kas_umum" DataTypeServer="integer(8)" DbType="Int64" Direction="Input" ParameterName="@tahun" Precision="0" ProviderType="Int64" Scale="0" Size="8" SourceColumn="tahun" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="SqliteNetConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="TotalPajakDisetor" Modifier="Public" Name="TotalPajakDisetor" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="TotalPajakDisetor">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        SUM(pengeluaran) AS TotalPajakDisetor
FROM            buku_kas_umum bku
WHERE        (bulan = @bulan) AND (tahun = @tahun) AND (kode IN ('112', '113', '114'))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="bulan" ColumnName="bulan" DataSourceName="main.buku_kas_umum" DataTypeServer="integer(8)" DbType="Int64" Direction="Input" ParameterName="@bulan" Precision="0" ProviderType="Int64" Scale="0" Size="8" SourceColumn="bulan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="tahun" ColumnName="tahun" DataSourceName="main.buku_kas_umum" DataTypeServer="integer(8)" DbType="Int64" Direction="Input" ParameterName="@tahun" Precision="0" ProviderType="Int64" Scale="0" Size="8" SourceColumn="tahun" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="SqliteNetConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="TotalPenerimaan" Modifier="Public" Name="TotalPenerimaan" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="TotalPenerimaan">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        SUM(penerimaan) AS TotalPenerimaan
FROM            buku_kas_umum bku
WHERE        (bulan = @bulan) AND (tahun = @tahun) AND (kode IN ('100', '1001'))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="bulan" ColumnName="bulan" DataSourceName="main.buku_kas_umum" DataTypeServer="integer(8)" DbType="Int64" Direction="Input" ParameterName="@bulan" Precision="0" ProviderType="Int64" Scale="0" Size="8" SourceColumn="bulan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="tahun" ColumnName="tahun" DataSourceName="main.buku_kas_umum" DataTypeServer="integer(8)" DbType="Int64" Direction="Input" ParameterName="@tahun" Precision="0" ProviderType="Int64" Scale="0" Size="8" SourceColumn="tahun" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="SqliteNetConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="TotalPengeluaran" Modifier="Public" Name="TotalPengeluaran" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="TotalPengeluaran">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        SUM(pengeluaran) AS TotalPengeluaran
FROM            buku_kas_umum
WHERE        (bulan = @bulan) AND (tahun = @tahun) AND (kode NOT IN ('100', '1001'))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="bulan" ColumnName="bulan" DataSourceName="main.buku_kas_umum" DataTypeServer="integer(8)" DbType="Int64" Direction="Input" ParameterName="@bulan" Precision="0" ProviderType="Int64" Scale="0" Size="8" SourceColumn="bulan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="tahun" ColumnName="tahun" DataSourceName="main.buku_kas_umum" DataTypeServer="integer(8)" DbType="Int64" Direction="Input" ParameterName="@tahun" Precision="0" ProviderType="Int64" Scale="0" Size="8" SourceColumn="tahun" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LaporanBulananTableAdapter" GeneratorDataComponentClassName="LaporanBulananTableAdapter" Name="LaporanBulanan" UserDataComponentName="LaporanBulananTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SqliteNetConnectionString (Settings)" DbObjectName="main.laporan_bulanan" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [main].[sqlite_default_schema].[laporan_bulanan] WHERE (([id] = @Original_id) AND ([bulan] = @Original_bulan) AND ([tahun] = @Original_tahun) AND ((@IsNull_no = 1 AND [no] IS NULL) OR ([no] = @Original_no)) AND ((@IsNull_uraian_penerimaan = 1 AND [uraian_penerimaan] IS NULL) OR ([uraian_penerimaan] = @Original_uraian_penerimaan)) AND ((@IsNull_beban_pk_penerimaan = 1 AND [beban_pk_penerimaan] IS NULL) OR ([beban_pk_penerimaan] = @Original_beban_pk_penerimaan)) AND ((@IsNull_jumlah_penerimaan = 1 AND [jumlah_penerimaan] IS NULL) OR ([jumlah_penerimaan] = @Original_jumlah_penerimaan)) AND ((@IsNull_uraian_pengeluaran = 1 AND [uraian_pengeluaran] IS NULL) OR ([uraian_pengeluaran] = @Original_uraian_pengeluaran)) AND ((@IsNull_beban_pk_pengeluaran = 1 AND [beban_pk_pengeluaran] IS NULL) OR ([beban_pk_pengeluaran] = @Original_beban_pk_pengeluaran)) AND ((@IsNull_jumlah_pengeluaran = 1 AND [jumlah_pengeluaran] IS NULL) OR ([jumlah_pengeluaran] = @Original_jumlah_pengeluaran)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_bulan" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="bulan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_tahun" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="tahun" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_no" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="no" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_no" Precision="0" ProviderType="AnsiString" Scale="0" Size="0" SourceColumn="no" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_uraian_penerimaan" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="uraian_penerimaan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_uraian_penerimaan" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="uraian_penerimaan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_beban_pk_penerimaan" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="beban_pk_penerimaan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_beban_pk_penerimaan" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="beban_pk_penerimaan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_jumlah_penerimaan" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="jumlah_penerimaan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_jumlah_penerimaan" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="jumlah_penerimaan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_uraian_pengeluaran" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="uraian_pengeluaran" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_uraian_pengeluaran" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="uraian_pengeluaran" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_beban_pk_pengeluaran" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="beban_pk_pengeluaran" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_beban_pk_pengeluaran" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="beban_pk_pengeluaran" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_jumlah_pengeluaran" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="jumlah_pengeluaran" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_jumlah_pengeluaran" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="jumlah_pengeluaran" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [main].[sqlite_default_schema].[laporan_bulanan] ([bulan], [tahun], [no], [uraian_penerimaan], [beban_pk_penerimaan], [jumlah_penerimaan], [uraian_pengeluaran], [beban_pk_pengeluaran], [jumlah_pengeluaran]) VALUES (@bulan, @tahun, @no, @uraian_penerimaan, @beban_pk_penerimaan, @jumlah_penerimaan, @uraian_pengeluaran, @beban_pk_pengeluaran, @jumlah_pengeluaran)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@bulan" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="bulan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@tahun" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="tahun" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@no" Precision="0" ProviderType="AnsiString" Scale="0" Size="0" SourceColumn="no" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@uraian_penerimaan" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="uraian_penerimaan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@beban_pk_penerimaan" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="beban_pk_penerimaan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@jumlah_penerimaan" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="jumlah_penerimaan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@uraian_pengeluaran" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="uraian_pengeluaran" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@beban_pk_pengeluaran" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="beban_pk_pengeluaran" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@jumlah_pengeluaran" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="jumlah_pengeluaran" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT [id], [bulan], [tahun], [no], [uraian_penerimaan], [beban_pk_penerimaan], [jumlah_penerimaan], [uraian_pengeluaran], [beban_pk_pengeluaran], [jumlah_pengeluaran] FROM [laporan_bulanan] where bulan = @bulan and tahun = @tahun</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="bulan" ColumnName="bulan" DataSourceName="main.laporan_bulanan" DataTypeServer="integer(8)" DbType="Int64" Direction="Input" ParameterName="@bulan" Precision="0" ProviderType="Int64" Scale="0" Size="8" SourceColumn="bulan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="tahun" ColumnName="tahun" DataSourceName="main.laporan_bulanan" DataTypeServer="integer(8)" DbType="Int64" Direction="Input" ParameterName="@tahun" Precision="0" ProviderType="Int64" Scale="0" Size="8" SourceColumn="tahun" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [main].[sqlite_default_schema].[laporan_bulanan] SET [bulan] = @bulan, [tahun] = @tahun, [no] = @no, [uraian_penerimaan] = @uraian_penerimaan, [beban_pk_penerimaan] = @beban_pk_penerimaan, [jumlah_penerimaan] = @jumlah_penerimaan, [uraian_pengeluaran] = @uraian_pengeluaran, [beban_pk_pengeluaran] = @beban_pk_pengeluaran, [jumlah_pengeluaran] = @jumlah_pengeluaran WHERE (([id] = @Original_id) AND ([bulan] = @Original_bulan) AND ([tahun] = @Original_tahun) AND ((@IsNull_no = 1 AND [no] IS NULL) OR ([no] = @Original_no)) AND ((@IsNull_uraian_penerimaan = 1 AND [uraian_penerimaan] IS NULL) OR ([uraian_penerimaan] = @Original_uraian_penerimaan)) AND ((@IsNull_beban_pk_penerimaan = 1 AND [beban_pk_penerimaan] IS NULL) OR ([beban_pk_penerimaan] = @Original_beban_pk_penerimaan)) AND ((@IsNull_jumlah_penerimaan = 1 AND [jumlah_penerimaan] IS NULL) OR ([jumlah_penerimaan] = @Original_jumlah_penerimaan)) AND ((@IsNull_uraian_pengeluaran = 1 AND [uraian_pengeluaran] IS NULL) OR ([uraian_pengeluaran] = @Original_uraian_pengeluaran)) AND ((@IsNull_beban_pk_pengeluaran = 1 AND [beban_pk_pengeluaran] IS NULL) OR ([beban_pk_pengeluaran] = @Original_beban_pk_pengeluaran)) AND ((@IsNull_jumlah_pengeluaran = 1 AND [jumlah_pengeluaran] IS NULL) OR ([jumlah_pengeluaran] = @Original_jumlah_pengeluaran)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@bulan" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="bulan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@tahun" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="tahun" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@no" Precision="0" ProviderType="AnsiString" Scale="0" Size="0" SourceColumn="no" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@uraian_penerimaan" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="uraian_penerimaan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@beban_pk_penerimaan" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="beban_pk_penerimaan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@jumlah_penerimaan" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="jumlah_penerimaan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@uraian_pengeluaran" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="uraian_pengeluaran" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@beban_pk_pengeluaran" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="beban_pk_pengeluaran" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@jumlah_pengeluaran" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="jumlah_pengeluaran" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_bulan" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="bulan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_tahun" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="tahun" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_no" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="no" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_no" Precision="0" ProviderType="AnsiString" Scale="0" Size="0" SourceColumn="no" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_uraian_penerimaan" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="uraian_penerimaan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_uraian_penerimaan" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="uraian_penerimaan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_beban_pk_penerimaan" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="beban_pk_penerimaan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_beban_pk_penerimaan" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="beban_pk_penerimaan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_jumlah_penerimaan" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="jumlah_penerimaan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_jumlah_penerimaan" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="jumlah_penerimaan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_uraian_pengeluaran" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="uraian_pengeluaran" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_uraian_pengeluaran" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="uraian_pengeluaran" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_beban_pk_pengeluaran" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="beban_pk_pengeluaran" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_beban_pk_pengeluaran" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="beban_pk_pengeluaran" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_jumlah_pengeluaran" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="jumlah_pengeluaran" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_jumlah_pengeluaran" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="jumlah_pengeluaran" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="bulan" DataSetColumn="bulan" />
              <Mapping SourceColumn="tahun" DataSetColumn="tahun" />
              <Mapping SourceColumn="no" DataSetColumn="no" />
              <Mapping SourceColumn="uraian_penerimaan" DataSetColumn="uraian_penerimaan" />
              <Mapping SourceColumn="beban_pk_penerimaan" DataSetColumn="beban_pk_penerimaan" />
              <Mapping SourceColumn="jumlah_penerimaan" DataSetColumn="jumlah_penerimaan" />
              <Mapping SourceColumn="uraian_pengeluaran" DataSetColumn="uraian_pengeluaran" />
              <Mapping SourceColumn="beban_pk_pengeluaran" DataSetColumn="beban_pk_pengeluaran" />
              <Mapping SourceColumn="jumlah_pengeluaran" DataSetColumn="jumlah_pengeluaran" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="SqliteNetConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="Exists" GetMethodModifier="Public" GetMethodName="Exists" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="Exists" UserSourceName="Exists">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>select exists(select * from laporan_bulanan where bulan = @bulan and tahun = @tahun) as exist</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="bulan" ColumnName="bulan" DataSourceName="" DataTypeServer="integer(8)" DbType="Int64" Direction="Input" ParameterName="@bulan" Precision="0" ProviderType="Int64" Scale="0" Size="8" SourceColumn="bulan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="tahun" ColumnName="tahun" DataSourceName="" DataTypeServer="integer(8)" DbType="Int64" Direction="Input" ParameterName="@tahun" Precision="0" ProviderType="Int64" Scale="0" Size="8" SourceColumn="tahun" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LaporanSemesterTableAdapter" GeneratorDataComponentClassName="LaporanSemesterTableAdapter" Name="LaporanSemester" UserDataComponentName="LaporanSemesterTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SqliteNetConnectionString (Settings)" DbObjectName="main.laporan_semester" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [main].[sqlite_default_schema].[laporan_semester] WHERE (([id] = @Original_id) AND ([semester] = @Original_semester) AND ([tahun] = @Original_tahun) AND ((@IsNull_no = 1 AND [no] IS NULL) OR ([no] = @Original_no)) AND ((@IsNull_uraian = 1 AND [uraian] IS NULL) OR ([uraian] = @Original_uraian)) AND ((@IsNull_prosentase_anggaran = 1 AND [prosentase_anggaran] IS NULL) OR ([prosentase_anggaran] = @Original_prosentase_anggaran)) AND ((@IsNull_jumlah_anggaran = 1 AND [jumlah_anggaran] IS NULL) OR ([jumlah_anggaran] = @Original_jumlah_anggaran)) AND ((@IsNull_realisasi_anggaran_1 = 1 AND [realisasi_anggaran_1] IS NULL) OR ([realisasi_anggaran_1] = @Original_realisasi_anggaran_1)) AND ((@IsNull_realisasi_anggaran_2 = 1 AND [realisasi_anggaran_2] IS NULL) OR ([realisasi_anggaran_2] = @Original_realisasi_anggaran_2)) AND ((@IsNull_realisasi_anggaran_3 = 1 AND [realisasi_anggaran_3] IS NULL) OR ([realisasi_anggaran_3] = @Original_realisasi_anggaran_3)) AND ((@IsNull_realisasi_anggaran_4 = 1 AND [realisasi_anggaran_4] IS NULL) OR ([realisasi_anggaran_4] = @Original_realisasi_anggaran_4)) AND ((@IsNull_jumlah_realisasi = 1 AND [jumlah_realisasi] IS NULL) OR ([jumlah_realisasi] = @Original_jumlah_realisasi)) AND ((@IsNull_prosentase_pajak = 1 AND [prosentase_pajak] IS NULL) OR ([prosentase_pajak] = @Original_prosentase_pajak)) AND ((@IsNull_pajak_yang_diterima = 1 AND [pajak_yang_diterima] IS NULL) OR ([pajak_yang_diterima] = @Original_pajak_yang_diterima)) AND ((@IsNull_pajak_yang_disetorkan = 1 AND [pajak_yang_disetorkan] IS NULL) OR ([pajak_yang_disetorkan] = @Original_pajak_yang_disetorkan)) AND ((@IsNull_sisa_dana = 1 AND [sisa_dana] IS NULL) OR ([sisa_dana] = @Original_sisa_dana)) AND ((@IsNull_keterangan = 1 AND [keterangan] IS NULL) OR ([keterangan] = @Original_keterangan)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_semester" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="semester" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_tahun" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="tahun" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_no" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="no" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_no" Precision="0" ProviderType="AnsiString" Scale="0" Size="0" SourceColumn="no" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_uraian" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="uraian" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_uraian" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="uraian" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_prosentase_anggaran" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="prosentase_anggaran" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_prosentase_anggaran" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="prosentase_anggaran" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_jumlah_anggaran" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="jumlah_anggaran" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_jumlah_anggaran" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="jumlah_anggaran" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_realisasi_anggaran_1" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="realisasi_anggaran_1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_realisasi_anggaran_1" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="realisasi_anggaran_1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_realisasi_anggaran_2" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="realisasi_anggaran_2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_realisasi_anggaran_2" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="realisasi_anggaran_2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_realisasi_anggaran_3" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="realisasi_anggaran_3" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_realisasi_anggaran_3" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="realisasi_anggaran_3" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_realisasi_anggaran_4" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="realisasi_anggaran_4" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_realisasi_anggaran_4" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="realisasi_anggaran_4" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_jumlah_realisasi" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="jumlah_realisasi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_jumlah_realisasi" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="jumlah_realisasi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_prosentase_pajak" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="prosentase_pajak" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_prosentase_pajak" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="prosentase_pajak" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_pajak_yang_diterima" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="pajak_yang_diterima" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_pajak_yang_diterima" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="pajak_yang_diterima" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_pajak_yang_disetorkan" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="pajak_yang_disetorkan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_pajak_yang_disetorkan" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="pajak_yang_disetorkan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sisa_dana" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="sisa_dana" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_sisa_dana" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="sisa_dana" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_keterangan" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="keterangan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_keterangan" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="keterangan" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [main].[sqlite_default_schema].[laporan_semester] ([semester], [tahun], [no], [uraian], [prosentase_anggaran], [jumlah_anggaran], [realisasi_anggaran_1], [realisasi_anggaran_2], [realisasi_anggaran_3], [realisasi_anggaran_4], [jumlah_realisasi], [prosentase_pajak], [pajak_yang_diterima], [pajak_yang_disetorkan], [sisa_dana], [keterangan]) VALUES (@semester, @tahun, @no, @uraian, @prosentase_anggaran, @jumlah_anggaran, @realisasi_anggaran_1, @realisasi_anggaran_2, @realisasi_anggaran_3, @realisasi_anggaran_4, @jumlah_realisasi, @prosentase_pajak, @pajak_yang_diterima, @pajak_yang_disetorkan, @sisa_dana, @keterangan)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@semester" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="semester" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@tahun" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="tahun" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@no" Precision="0" ProviderType="AnsiString" Scale="0" Size="0" SourceColumn="no" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@uraian" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="uraian" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@prosentase_anggaran" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="prosentase_anggaran" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@jumlah_anggaran" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="jumlah_anggaran" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@realisasi_anggaran_1" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="realisasi_anggaran_1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@realisasi_anggaran_2" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="realisasi_anggaran_2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@realisasi_anggaran_3" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="realisasi_anggaran_3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@realisasi_anggaran_4" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="realisasi_anggaran_4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@jumlah_realisasi" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="jumlah_realisasi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@prosentase_pajak" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="prosentase_pajak" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@pajak_yang_diterima" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="pajak_yang_diterima" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@pajak_yang_disetorkan" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="pajak_yang_disetorkan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@sisa_dana" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="sisa_dana" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@keterangan" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="keterangan" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT [id], [semester], [tahun], [no], [uraian], [prosentase_anggaran], [jumlah_anggaran], [realisasi_anggaran_1], [realisasi_anggaran_2], [realisasi_anggaran_3], [realisasi_anggaran_4], [jumlah_realisasi], [prosentase_pajak], [pajak_yang_diterima], [pajak_yang_disetorkan], [sisa_dana], [keterangan] FROM [laporan_semester] where semester = @semester and tahun = @tahun</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="semester" ColumnName="semester" DataSourceName="main.laporan_semester" DataTypeServer="integer(8)" DbType="Int64" Direction="Input" ParameterName="@semester" Precision="0" ProviderType="Int64" Scale="0" Size="8" SourceColumn="semester" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="tahun" ColumnName="tahun" DataSourceName="main.laporan_semester" DataTypeServer="integer(8)" DbType="Int64" Direction="Input" ParameterName="@tahun" Precision="0" ProviderType="Int64" Scale="0" Size="8" SourceColumn="tahun" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [main].[sqlite_default_schema].[laporan_semester] SET [semester] = @semester, [tahun] = @tahun, [no] = @no, [uraian] = @uraian, [prosentase_anggaran] = @prosentase_anggaran, [jumlah_anggaran] = @jumlah_anggaran, [realisasi_anggaran_1] = @realisasi_anggaran_1, [realisasi_anggaran_2] = @realisasi_anggaran_2, [realisasi_anggaran_3] = @realisasi_anggaran_3, [realisasi_anggaran_4] = @realisasi_anggaran_4, [jumlah_realisasi] = @jumlah_realisasi, [prosentase_pajak] = @prosentase_pajak, [pajak_yang_diterima] = @pajak_yang_diterima, [pajak_yang_disetorkan] = @pajak_yang_disetorkan, [sisa_dana] = @sisa_dana, [keterangan] = @keterangan WHERE (([id] = @Original_id) AND ([semester] = @Original_semester) AND ([tahun] = @Original_tahun) AND ((@IsNull_no = 1 AND [no] IS NULL) OR ([no] = @Original_no)) AND ((@IsNull_uraian = 1 AND [uraian] IS NULL) OR ([uraian] = @Original_uraian)) AND ((@IsNull_prosentase_anggaran = 1 AND [prosentase_anggaran] IS NULL) OR ([prosentase_anggaran] = @Original_prosentase_anggaran)) AND ((@IsNull_jumlah_anggaran = 1 AND [jumlah_anggaran] IS NULL) OR ([jumlah_anggaran] = @Original_jumlah_anggaran)) AND ((@IsNull_realisasi_anggaran_1 = 1 AND [realisasi_anggaran_1] IS NULL) OR ([realisasi_anggaran_1] = @Original_realisasi_anggaran_1)) AND ((@IsNull_realisasi_anggaran_2 = 1 AND [realisasi_anggaran_2] IS NULL) OR ([realisasi_anggaran_2] = @Original_realisasi_anggaran_2)) AND ((@IsNull_realisasi_anggaran_3 = 1 AND [realisasi_anggaran_3] IS NULL) OR ([realisasi_anggaran_3] = @Original_realisasi_anggaran_3)) AND ((@IsNull_realisasi_anggaran_4 = 1 AND [realisasi_anggaran_4] IS NULL) OR ([realisasi_anggaran_4] = @Original_realisasi_anggaran_4)) AND ((@IsNull_jumlah_realisasi = 1 AND [jumlah_realisasi] IS NULL) OR ([jumlah_realisasi] = @Original_jumlah_realisasi)) AND ((@IsNull_prosentase_pajak = 1 AND [prosentase_pajak] IS NULL) OR ([prosentase_pajak] = @Original_prosentase_pajak)) AND ((@IsNull_pajak_yang_diterima = 1 AND [pajak_yang_diterima] IS NULL) OR ([pajak_yang_diterima] = @Original_pajak_yang_diterima)) AND ((@IsNull_pajak_yang_disetorkan = 1 AND [pajak_yang_disetorkan] IS NULL) OR ([pajak_yang_disetorkan] = @Original_pajak_yang_disetorkan)) AND ((@IsNull_sisa_dana = 1 AND [sisa_dana] IS NULL) OR ([sisa_dana] = @Original_sisa_dana)) AND ((@IsNull_keterangan = 1 AND [keterangan] IS NULL) OR ([keterangan] = @Original_keterangan)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@semester" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="semester" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@tahun" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="tahun" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@no" Precision="0" ProviderType="AnsiString" Scale="0" Size="0" SourceColumn="no" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@uraian" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="uraian" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@prosentase_anggaran" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="prosentase_anggaran" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@jumlah_anggaran" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="jumlah_anggaran" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@realisasi_anggaran_1" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="realisasi_anggaran_1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@realisasi_anggaran_2" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="realisasi_anggaran_2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@realisasi_anggaran_3" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="realisasi_anggaran_3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@realisasi_anggaran_4" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="realisasi_anggaran_4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@jumlah_realisasi" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="jumlah_realisasi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@prosentase_pajak" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="prosentase_pajak" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@pajak_yang_diterima" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="pajak_yang_diterima" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@pajak_yang_disetorkan" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="pajak_yang_disetorkan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@sisa_dana" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="sisa_dana" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@keterangan" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="keterangan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_semester" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="semester" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_tahun" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="tahun" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_no" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="no" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_no" Precision="0" ProviderType="AnsiString" Scale="0" Size="0" SourceColumn="no" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_uraian" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="uraian" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_uraian" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="uraian" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_prosentase_anggaran" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="prosentase_anggaran" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_prosentase_anggaran" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="prosentase_anggaran" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_jumlah_anggaran" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="jumlah_anggaran" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_jumlah_anggaran" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="jumlah_anggaran" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_realisasi_anggaran_1" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="realisasi_anggaran_1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_realisasi_anggaran_1" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="realisasi_anggaran_1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_realisasi_anggaran_2" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="realisasi_anggaran_2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_realisasi_anggaran_2" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="realisasi_anggaran_2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_realisasi_anggaran_3" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="realisasi_anggaran_3" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_realisasi_anggaran_3" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="realisasi_anggaran_3" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_realisasi_anggaran_4" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="realisasi_anggaran_4" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_realisasi_anggaran_4" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="realisasi_anggaran_4" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_jumlah_realisasi" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="jumlah_realisasi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_jumlah_realisasi" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="jumlah_realisasi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_prosentase_pajak" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="prosentase_pajak" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_prosentase_pajak" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="prosentase_pajak" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_pajak_yang_diterima" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="pajak_yang_diterima" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_pajak_yang_diterima" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="pajak_yang_diterima" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_pajak_yang_disetorkan" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="pajak_yang_disetorkan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_pajak_yang_disetorkan" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="pajak_yang_disetorkan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sisa_dana" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="sisa_dana" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_sisa_dana" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="sisa_dana" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_keterangan" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="keterangan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_keterangan" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="keterangan" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="semester" DataSetColumn="semester" />
              <Mapping SourceColumn="tahun" DataSetColumn="tahun" />
              <Mapping SourceColumn="no" DataSetColumn="no" />
              <Mapping SourceColumn="uraian" DataSetColumn="uraian" />
              <Mapping SourceColumn="prosentase_anggaran" DataSetColumn="prosentase_anggaran" />
              <Mapping SourceColumn="jumlah_anggaran" DataSetColumn="jumlah_anggaran" />
              <Mapping SourceColumn="realisasi_anggaran_1" DataSetColumn="realisasi_anggaran_1" />
              <Mapping SourceColumn="realisasi_anggaran_2" DataSetColumn="realisasi_anggaran_2" />
              <Mapping SourceColumn="realisasi_anggaran_3" DataSetColumn="realisasi_anggaran_3" />
              <Mapping SourceColumn="realisasi_anggaran_4" DataSetColumn="realisasi_anggaran_4" />
              <Mapping SourceColumn="jumlah_realisasi" DataSetColumn="jumlah_realisasi" />
              <Mapping SourceColumn="prosentase_pajak" DataSetColumn="prosentase_pajak" />
              <Mapping SourceColumn="pajak_yang_diterima" DataSetColumn="pajak_yang_diterima" />
              <Mapping SourceColumn="pajak_yang_disetorkan" DataSetColumn="pajak_yang_disetorkan" />
              <Mapping SourceColumn="sisa_dana" DataSetColumn="sisa_dana" />
              <Mapping SourceColumn="keterangan" DataSetColumn="keterangan" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="SqliteNetConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="Exists" GetMethodModifier="Public" GetMethodName="Exists" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="Exists" UserSourceName="Exists">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>select exists(select * from laporan_semester where semester = @semester and tahun = @tahun) as exist</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="semester" ColumnName="semester" DataSourceName="" DataTypeServer="integer(8)" DbType="Int64" Direction="Input" ParameterName="@semester" Precision="0" ProviderType="Int64" Scale="0" Size="8" SourceColumn="semester" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="tahun" ColumnName="tahun" DataSourceName="" DataTypeServer="integer(8)" DbType="Int64" Direction="Input" ParameterName="@tahun" Precision="0" ProviderType="Int64" Scale="0" Size="8" SourceColumn="tahun" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LaporanTriwulanTableAdapter" GeneratorDataComponentClassName="LaporanTriwulanTableAdapter" Name="LaporanTriwulan" UserDataComponentName="LaporanTriwulanTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SqliteNetConnectionString (Settings)" DbObjectName="main.laporan_triwulan" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [main].[sqlite_default_schema].[laporan_triwulan] WHERE (([id] = @Original_id) AND ([triwulan] = @Original_triwulan) AND ([tahun] = @Original_tahun) AND ((@IsNull_no = 1 AND [no] IS NULL) OR ([no] = @Original_no)) AND ((@IsNull_uraian = 1 AND [uraian] IS NULL) OR ([uraian] = @Original_uraian)) AND ((@IsNull_prosentase_anggaran = 1 AND [prosentase_anggaran] IS NULL) OR ([prosentase_anggaran] = @Original_prosentase_anggaran)) AND ((@IsNull_jumlah_anggaran = 1 AND [jumlah_anggaran] IS NULL) OR ([jumlah_anggaran] = @Original_jumlah_anggaran)) AND ((@IsNull_jumlah_realisasi = 1 AND [jumlah_realisasi] IS NULL) OR ([jumlah_realisasi] = @Original_jumlah_realisasi)) AND ((@IsNull_prosentase_pajak = 1 AND [prosentase_pajak] IS NULL) OR ([prosentase_pajak] = @Original_prosentase_pajak)) AND ((@IsNull_pajak_yang_diterima = 1 AND [pajak_yang_diterima] IS NULL) OR ([pajak_yang_diterima] = @Original_pajak_yang_diterima)) AND ((@IsNull_pajak_yang_disetorkan = 1 AND [pajak_yang_disetorkan] IS NULL) OR ([pajak_yang_disetorkan] = @Original_pajak_yang_disetorkan)) AND ((@IsNull_sisa_dana = 1 AND [sisa_dana] IS NULL) OR ([sisa_dana] = @Original_sisa_dana)) AND ((@IsNull_keterangan = 1 AND [keterangan] IS NULL) OR ([keterangan] = @Original_keterangan)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_triwulan" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="triwulan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_tahun" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="tahun" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_no" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="no" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_no" Precision="0" ProviderType="AnsiString" Scale="0" Size="0" SourceColumn="no" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_uraian" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="uraian" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_uraian" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="uraian" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_prosentase_anggaran" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="prosentase_anggaran" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_prosentase_anggaran" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="prosentase_anggaran" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_jumlah_anggaran" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="jumlah_anggaran" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_jumlah_anggaran" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="jumlah_anggaran" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_jumlah_realisasi" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="jumlah_realisasi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_jumlah_realisasi" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="jumlah_realisasi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_prosentase_pajak" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="prosentase_pajak" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_prosentase_pajak" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="prosentase_pajak" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_pajak_yang_diterima" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="pajak_yang_diterima" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_pajak_yang_diterima" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="pajak_yang_diterima" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_pajak_yang_disetorkan" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="pajak_yang_disetorkan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_pajak_yang_disetorkan" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="pajak_yang_disetorkan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sisa_dana" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="sisa_dana" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_sisa_dana" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="sisa_dana" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_keterangan" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="keterangan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_keterangan" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="keterangan" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [main].[sqlite_default_schema].[laporan_triwulan] ([triwulan], [tahun], [no], [uraian], [prosentase_anggaran], [jumlah_anggaran], [jumlah_realisasi], [prosentase_pajak], [pajak_yang_diterima], [pajak_yang_disetorkan], [sisa_dana], [keterangan]) VALUES (@triwulan, @tahun, @no, @uraian, @prosentase_anggaran, @jumlah_anggaran, @jumlah_realisasi, @prosentase_pajak, @pajak_yang_diterima, @pajak_yang_disetorkan, @sisa_dana, @keterangan)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@triwulan" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="triwulan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@tahun" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="tahun" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@no" Precision="0" ProviderType="AnsiString" Scale="0" Size="0" SourceColumn="no" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@uraian" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="uraian" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@prosentase_anggaran" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="prosentase_anggaran" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@jumlah_anggaran" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="jumlah_anggaran" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@jumlah_realisasi" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="jumlah_realisasi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@prosentase_pajak" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="prosentase_pajak" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@pajak_yang_diterima" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="pajak_yang_diterima" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@pajak_yang_disetorkan" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="pajak_yang_disetorkan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@sisa_dana" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="sisa_dana" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@keterangan" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="keterangan" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT [id], [triwulan], [tahun], [no], [uraian], [prosentase_anggaran], [jumlah_anggaran], [jumlah_realisasi], [prosentase_pajak], [pajak_yang_diterima], [pajak_yang_disetorkan], [sisa_dana], [keterangan] FROM [laporan_triwulan] where triwulan = @triwulan and tahun = @tahun</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="triwulan" ColumnName="triwulan" DataSourceName="main.laporan_triwulan" DataTypeServer="integer(8)" DbType="Int64" Direction="Input" ParameterName="@triwulan" Precision="0" ProviderType="Int64" Scale="0" Size="8" SourceColumn="triwulan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="tahun" ColumnName="tahun" DataSourceName="main.laporan_triwulan" DataTypeServer="integer(8)" DbType="Int64" Direction="Input" ParameterName="@tahun" Precision="0" ProviderType="Int64" Scale="0" Size="8" SourceColumn="tahun" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [main].[sqlite_default_schema].[laporan_triwulan] SET [triwulan] = @triwulan, [tahun] = @tahun, [no] = @no, [uraian] = @uraian, [prosentase_anggaran] = @prosentase_anggaran, [jumlah_anggaran] = @jumlah_anggaran, [jumlah_realisasi] = @jumlah_realisasi, [prosentase_pajak] = @prosentase_pajak, [pajak_yang_diterima] = @pajak_yang_diterima, [pajak_yang_disetorkan] = @pajak_yang_disetorkan, [sisa_dana] = @sisa_dana, [keterangan] = @keterangan WHERE (([id] = @Original_id) AND ([triwulan] = @Original_triwulan) AND ([tahun] = @Original_tahun) AND ((@IsNull_no = 1 AND [no] IS NULL) OR ([no] = @Original_no)) AND ((@IsNull_uraian = 1 AND [uraian] IS NULL) OR ([uraian] = @Original_uraian)) AND ((@IsNull_prosentase_anggaran = 1 AND [prosentase_anggaran] IS NULL) OR ([prosentase_anggaran] = @Original_prosentase_anggaran)) AND ((@IsNull_jumlah_anggaran = 1 AND [jumlah_anggaran] IS NULL) OR ([jumlah_anggaran] = @Original_jumlah_anggaran)) AND ((@IsNull_jumlah_realisasi = 1 AND [jumlah_realisasi] IS NULL) OR ([jumlah_realisasi] = @Original_jumlah_realisasi)) AND ((@IsNull_prosentase_pajak = 1 AND [prosentase_pajak] IS NULL) OR ([prosentase_pajak] = @Original_prosentase_pajak)) AND ((@IsNull_pajak_yang_diterima = 1 AND [pajak_yang_diterima] IS NULL) OR ([pajak_yang_diterima] = @Original_pajak_yang_diterima)) AND ((@IsNull_pajak_yang_disetorkan = 1 AND [pajak_yang_disetorkan] IS NULL) OR ([pajak_yang_disetorkan] = @Original_pajak_yang_disetorkan)) AND ((@IsNull_sisa_dana = 1 AND [sisa_dana] IS NULL) OR ([sisa_dana] = @Original_sisa_dana)) AND ((@IsNull_keterangan = 1 AND [keterangan] IS NULL) OR ([keterangan] = @Original_keterangan)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@triwulan" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="triwulan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@tahun" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="tahun" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@no" Precision="0" ProviderType="AnsiString" Scale="0" Size="0" SourceColumn="no" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@uraian" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="uraian" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@prosentase_anggaran" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="prosentase_anggaran" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@jumlah_anggaran" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="jumlah_anggaran" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@jumlah_realisasi" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="jumlah_realisasi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@prosentase_pajak" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="prosentase_pajak" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@pajak_yang_diterima" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="pajak_yang_diterima" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@pajak_yang_disetorkan" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="pajak_yang_disetorkan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@sisa_dana" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="sisa_dana" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@keterangan" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="keterangan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_triwulan" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="triwulan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_tahun" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="tahun" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_no" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="no" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_no" Precision="0" ProviderType="AnsiString" Scale="0" Size="0" SourceColumn="no" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_uraian" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="uraian" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_uraian" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="uraian" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_prosentase_anggaran" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="prosentase_anggaran" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_prosentase_anggaran" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="prosentase_anggaran" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_jumlah_anggaran" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="jumlah_anggaran" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_jumlah_anggaran" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="jumlah_anggaran" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_jumlah_realisasi" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="jumlah_realisasi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_jumlah_realisasi" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="jumlah_realisasi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_prosentase_pajak" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="prosentase_pajak" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_prosentase_pajak" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="prosentase_pajak" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_pajak_yang_diterima" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="pajak_yang_diterima" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_pajak_yang_diterima" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="pajak_yang_diterima" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_pajak_yang_disetorkan" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="pajak_yang_disetorkan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_pajak_yang_disetorkan" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="pajak_yang_disetorkan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sisa_dana" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="sisa_dana" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_sisa_dana" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="sisa_dana" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_keterangan" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="keterangan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_keterangan" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="keterangan" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="triwulan" DataSetColumn="triwulan" />
              <Mapping SourceColumn="tahun" DataSetColumn="tahun" />
              <Mapping SourceColumn="no" DataSetColumn="no" />
              <Mapping SourceColumn="uraian" DataSetColumn="uraian" />
              <Mapping SourceColumn="prosentase_anggaran" DataSetColumn="prosentase_anggaran" />
              <Mapping SourceColumn="jumlah_anggaran" DataSetColumn="jumlah_anggaran" />
              <Mapping SourceColumn="jumlah_realisasi" DataSetColumn="jumlah_realisasi" />
              <Mapping SourceColumn="prosentase_pajak" DataSetColumn="prosentase_pajak" />
              <Mapping SourceColumn="pajak_yang_diterima" DataSetColumn="pajak_yang_diterima" />
              <Mapping SourceColumn="pajak_yang_disetorkan" DataSetColumn="pajak_yang_disetorkan" />
              <Mapping SourceColumn="sisa_dana" DataSetColumn="sisa_dana" />
              <Mapping SourceColumn="keterangan" DataSetColumn="keterangan" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProfilTableAdapter" GeneratorDataComponentClassName="ProfilTableAdapter" Name="Profil" UserDataComponentName="ProfilTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SqliteNetConnectionString (Settings)" DbObjectName="main.profil" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [main].[sqlite_default_schema].[profil] WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [main].[sqlite_default_schema].[profil] ([yayasan], [ketua_yayasan], [sekolah], [kepala_sekolah], [bendahara_sekolah]) VALUES (@yayasan, @ketua_yayasan, @sekolah, @kepala_sekolah, @bendahara_sekolah)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@yayasan" Precision="0" ProviderType="AnsiString" Scale="0" Size="0" SourceColumn="yayasan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ketua_yayasan" Precision="0" ProviderType="AnsiString" Scale="0" Size="0" SourceColumn="ketua_yayasan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@sekolah" Precision="0" ProviderType="AnsiString" Scale="0" Size="0" SourceColumn="sekolah" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@kepala_sekolah" Precision="0" ProviderType="AnsiString" Scale="0" Size="0" SourceColumn="kepala_sekolah" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@bendahara_sekolah" Precision="0" ProviderType="AnsiString" Scale="0" Size="0" SourceColumn="bendahara_sekolah" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT * FROM profil</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [main].[sqlite_default_schema].[profil] SET [yayasan] = @yayasan, [ketua_yayasan] = @ketua_yayasan, [sekolah] = @sekolah, [kepala_sekolah] = @kepala_sekolah, [bendahara_sekolah] = @bendahara_sekolah WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@yayasan" Precision="0" ProviderType="AnsiString" Scale="0" Size="0" SourceColumn="yayasan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ketua_yayasan" Precision="0" ProviderType="AnsiString" Scale="0" Size="0" SourceColumn="ketua_yayasan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@sekolah" Precision="0" ProviderType="AnsiString" Scale="0" Size="0" SourceColumn="sekolah" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@kepala_sekolah" Precision="0" ProviderType="AnsiString" Scale="0" Size="0" SourceColumn="kepala_sekolah" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@bendahara_sekolah" Precision="0" ProviderType="AnsiString" Scale="0" Size="0" SourceColumn="bendahara_sekolah" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="yayasan" DataSetColumn="yayasan" />
              <Mapping SourceColumn="ketua_yayasan" DataSetColumn="ketua_yayasan" />
              <Mapping SourceColumn="sekolah" DataSetColumn="sekolah" />
              <Mapping SourceColumn="kepala_sekolah" DataSetColumn="kepala_sekolah" />
              <Mapping SourceColumn="bendahara_sekolah" DataSetColumn="bendahara_sekolah" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UraianPenggunaanTableAdapter" GeneratorDataComponentClassName="UraianPenggunaanTableAdapter" Name="UraianPenggunaan" UserDataComponentName="UraianPenggunaanTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SqliteNetConnectionString (Settings)" DbObjectName="main.uraian_penggunaan" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [main].[sqlite_default_schema].[uraian_penggunaan] WHERE (([Id] = @Original_Id) AND ((@IsNull_kode_rekening = 1 AND [kode_rekening] IS NULL) OR ([kode_rekening] = @Original_kode_rekening)) AND ((@IsNull_uraian = 1 AND [uraian] IS NULL) OR ([uraian] = @Original_uraian)) AND ((@IsNull_kode = 1 AND [kode] IS NULL) OR ([kode] = @Original_kode)) AND ((@IsNull_tipe = 1 AND [tipe] IS NULL) OR ([tipe] = @Original_tipe)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_kode_rekening" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="kode_rekening" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_kode_rekening" Precision="0" ProviderType="AnsiString" Scale="0" Size="0" SourceColumn="kode_rekening" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_uraian" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="uraian" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_uraian" Precision="0" ProviderType="AnsiString" Scale="0" Size="0" SourceColumn="uraian" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_kode" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="kode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_kode" Precision="0" ProviderType="AnsiString" Scale="0" Size="0" SourceColumn="kode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tipe" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="tipe" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_tipe" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="tipe" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [main].[sqlite_default_schema].[uraian_penggunaan] ([kode_rekening], [uraian], [kode], [tipe]) VALUES (@kode_rekening, @uraian, @kode, @tipe)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@kode_rekening" Precision="0" ProviderType="AnsiString" Scale="0" Size="0" SourceColumn="kode_rekening" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@uraian" Precision="0" ProviderType="AnsiString" Scale="0" Size="0" SourceColumn="uraian" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@kode" Precision="0" ProviderType="AnsiString" Scale="0" Size="0" SourceColumn="kode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@tipe" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="tipe" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>select * from uraian_penggunaan</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [main].[sqlite_default_schema].[uraian_penggunaan] SET [kode_rekening] = @kode_rekening, [uraian] = @uraian, [kode] = @kode, [tipe] = @tipe WHERE (([Id] = @Original_Id) AND ((@IsNull_kode_rekening = 1 AND [kode_rekening] IS NULL) OR ([kode_rekening] = @Original_kode_rekening)) AND ((@IsNull_uraian = 1 AND [uraian] IS NULL) OR ([uraian] = @Original_uraian)) AND ((@IsNull_kode = 1 AND [kode] IS NULL) OR ([kode] = @Original_kode)) AND ((@IsNull_tipe = 1 AND [tipe] IS NULL) OR ([tipe] = @Original_tipe)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@kode_rekening" Precision="0" ProviderType="AnsiString" Scale="0" Size="0" SourceColumn="kode_rekening" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@uraian" Precision="0" ProviderType="AnsiString" Scale="0" Size="0" SourceColumn="uraian" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@kode" Precision="0" ProviderType="AnsiString" Scale="0" Size="0" SourceColumn="kode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@tipe" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="tipe" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_kode_rekening" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="kode_rekening" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_kode_rekening" Precision="0" ProviderType="AnsiString" Scale="0" Size="0" SourceColumn="kode_rekening" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_uraian" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="uraian" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_uraian" Precision="0" ProviderType="AnsiString" Scale="0" Size="0" SourceColumn="uraian" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_kode" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="kode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_kode" Precision="0" ProviderType="AnsiString" Scale="0" Size="0" SourceColumn="kode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tipe" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="tipe" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_tipe" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="tipe" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="kode_rekening" DataSetColumn="kode_rekening" />
              <Mapping SourceColumn="uraian" DataSetColumn="uraian" />
              <Mapping SourceColumn="kode" DataSetColumn="kode" />
              <Mapping SourceColumn="tipe" DataSetColumn="tipe" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="SqliteNetConnectionString (Settings)" DbObjectName="main.uraian_penggunaan" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByTipe" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByTipe" GeneratorSourceName="FillByTipe" GetMethodModifier="Public" GetMethodName="GetDataByTipe" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByTipe" UserSourceName="FillByTipe">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>select * from uraian_penggunaan where tipe = @tipe order by kode</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="tipe" ColumnName="tipe" DataSourceName="main.uraian_penggunaan" DataTypeServer="integer(8)" DbType="Int64" Direction="Input" ParameterName="@tipe" Precision="0" ProviderType="Int64" Scale="0" Size="8" SourceColumn="tipe" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProfilSekolahTableAdapter" GeneratorDataComponentClassName="ProfilSekolahTableAdapter" Name="ProfilSekolah" UserDataComponentName="ProfilSekolahTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SqliteNetConnectionString (Settings)" DbObjectName="main.profil_sekolah" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [main].[sqlite_default_schema].[profil_sekolah] WHERE (([id] = @Original_id) AND ((@IsNull_yayasan = 1 AND [yayasan] IS NULL) OR ([yayasan] = @Original_yayasan)) AND ((@IsNull_ketua_yayasan = 1 AND [ketua_yayasan] IS NULL) OR ([ketua_yayasan] = @Original_ketua_yayasan)) AND ((@IsNull_sekolah = 1 AND [sekolah] IS NULL) OR ([sekolah] = @Original_sekolah)) AND ((@IsNull_kepala_sekolah = 1 AND [kepala_sekolah] IS NULL) OR ([kepala_sekolah] = @Original_kepala_sekolah)) AND ((@IsNull_bendahara_sekolah = 1 AND [bendahara_sekolah] IS NULL) OR ([bendahara_sekolah] = @Original_bendahara_sekolah)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_yayasan" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="yayasan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_yayasan" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="yayasan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ketua_yayasan" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="ketua_yayasan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ketua_yayasan" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="ketua_yayasan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sekolah" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="sekolah" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sekolah" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="sekolah" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_kepala_sekolah" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="kepala_sekolah" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_kepala_sekolah" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="kepala_sekolah" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bendahara_sekolah" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="bendahara_sekolah" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_bendahara_sekolah" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="bendahara_sekolah" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [main].[sqlite_default_schema].[profil_sekolah] ([yayasan], [ketua_yayasan], [sekolah], [kepala_sekolah], [bendahara_sekolah]) VALUES (@yayasan, @ketua_yayasan, @sekolah, @kepala_sekolah, @bendahara_sekolah)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@yayasan" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="yayasan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ketua_yayasan" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="ketua_yayasan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sekolah" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="sekolah" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@kepala_sekolah" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="kepala_sekolah" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@bendahara_sekolah" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="bendahara_sekolah" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>select  * from profil_sekolah</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [main].[sqlite_default_schema].[profil_sekolah] SET [yayasan] = @yayasan, [ketua_yayasan] = @ketua_yayasan, [sekolah] = @sekolah, [kepala_sekolah] = @kepala_sekolah, [bendahara_sekolah] = @bendahara_sekolah WHERE (([id] = @Original_id) AND ((@IsNull_yayasan = 1 AND [yayasan] IS NULL) OR ([yayasan] = @Original_yayasan)) AND ((@IsNull_ketua_yayasan = 1 AND [ketua_yayasan] IS NULL) OR ([ketua_yayasan] = @Original_ketua_yayasan)) AND ((@IsNull_sekolah = 1 AND [sekolah] IS NULL) OR ([sekolah] = @Original_sekolah)) AND ((@IsNull_kepala_sekolah = 1 AND [kepala_sekolah] IS NULL) OR ([kepala_sekolah] = @Original_kepala_sekolah)) AND ((@IsNull_bendahara_sekolah = 1 AND [bendahara_sekolah] IS NULL) OR ([bendahara_sekolah] = @Original_bendahara_sekolah)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@yayasan" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="yayasan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ketua_yayasan" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="ketua_yayasan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@sekolah" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="sekolah" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@kepala_sekolah" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="kepala_sekolah" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@bendahara_sekolah" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="bendahara_sekolah" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_yayasan" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="yayasan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_yayasan" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="yayasan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ketua_yayasan" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="ketua_yayasan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ketua_yayasan" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="ketua_yayasan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sekolah" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="sekolah" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_sekolah" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="sekolah" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_kepala_sekolah" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="kepala_sekolah" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_kepala_sekolah" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="kepala_sekolah" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bendahara_sekolah" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="bendahara_sekolah" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_bendahara_sekolah" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="bendahara_sekolah" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="yayasan" DataSetColumn="yayasan" />
              <Mapping SourceColumn="ketua_yayasan" DataSetColumn="ketua_yayasan" />
              <Mapping SourceColumn="sekolah" DataSetColumn="sekolah" />
              <Mapping SourceColumn="kepala_sekolah" DataSetColumn="kepala_sekolah" />
              <Mapping SourceColumn="bendahara_sekolah" DataSetColumn="bendahara_sekolah" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ActivationTableAdapter" GeneratorDataComponentClassName="ActivationTableAdapter" Name="Activation" UserDataComponentName="ActivationTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SqliteNetConnectionString (Settings)" DbObjectName="main.activation" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [main].[sqlite_default_schema].[activation] WHERE (([product_number] = @Original_product_number))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_product_number" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="product_number" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [main].[sqlite_default_schema].[activation] ([product_number], [activation_code], [valid], [mac_address]) VALUES (@product_number, @activation_code, @valid, @mac_address)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@product_number" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="product_number" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@activation_code" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="activation_code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@valid" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="valid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@mac_address" Precision="0" ProviderType="AnsiString" Scale="0" Size="0" SourceColumn="mac_address" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>select * from activation</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [main].[sqlite_default_schema].[activation] SET [product_number] = @product_number, [activation_code] = @activation_code, [valid] = @valid, [mac_address] = @mac_address WHERE (([product_number] = @Original_product_number))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@product_number" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="product_number" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@activation_code" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="activation_code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@valid" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="valid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@mac_address" Precision="0" ProviderType="AnsiString" Scale="0" Size="0" SourceColumn="mac_address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_product_number" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="product_number" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="product_number" DataSetColumn="product_number" />
              <Mapping SourceColumn="activation_code" DataSetColumn="activation_code" />
              <Mapping SourceColumn="valid" DataSetColumn="valid" />
              <Mapping SourceColumn="mac_address" DataSetColumn="mac_address" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="BukuKasUmum" msprop:Generator_TableClassName="BukuKasUmumDataTable" msprop:Generator_TableVarName="tableBukuKasUmum" msprop:Generator_TablePropName="BukuKasUmum" msprop:Generator_RowDeletingName="BukuKasUmumRowDeleting" msprop:Generator_RowChangingName="BukuKasUmumRowChanging" msprop:Generator_RowEvHandlerName="BukuKasUmumRowChangeEventHandler" msprop:Generator_RowDeletedName="BukuKasUmumRowDeleted" msprop:Generator_UserTableName="BukuKasUmum" msprop:Generator_RowChangedName="BukuKasUmumRowChanged" msprop:Generator_RowEvArgName="BukuKasUmumRowChangeEvent" msprop:Generator_RowClassName="BukuKasUmumRow">
    <xs:complexType>
      <xs:sequence>
        <xs:element name="id" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:long" />
        <xs:element name="bulan" msprop:Generator_ColumnVarNameInTable="columnbulan" msprop:Generator_ColumnPropNameInRow="bulan" msprop:Generator_ColumnPropNameInTable="bulanColumn" msprop:Generator_UserColumnName="bulan" type="xs:long" />
        <xs:element name="tahun" msprop:Generator_ColumnVarNameInTable="columntahun" msprop:Generator_ColumnPropNameInRow="tahun" msprop:Generator_ColumnPropNameInTable="tahunColumn" msprop:Generator_UserColumnName="tahun" type="xs:long" />
        <xs:element name="no" msprop:Generator_ColumnVarNameInTable="columnno" msprop:Generator_ColumnPropNameInRow="no" msprop:Generator_ColumnPropNameInTable="noColumn" msprop:Generator_UserColumnName="no" minOccurs="0">
          <xs:simpleType>
            <xs:restriction base="xs:string">
              <xs:maxLength value="2147483647" />
            </xs:restriction>
          </xs:simpleType>
        </xs:element>
        <xs:element name="tanggal" msprop:Generator_ColumnVarNameInTable="columntanggal" msprop:Generator_ColumnPropNameInRow="tanggal" msprop:Generator_ColumnPropNameInTable="tanggalColumn" msprop:Generator_UserColumnName="tanggal" type="xs:dateTime" minOccurs="0" />
        <xs:element name="uraian" msprop:Generator_ColumnVarNameInTable="columnuraian" msprop:Generator_ColumnPropNameInRow="uraian" msprop:Generator_ColumnPropNameInTable="uraianColumn" msprop:Generator_UserColumnName="uraian" minOccurs="0">
          <xs:simpleType>
            <xs:restriction base="xs:string">
              <xs:maxLength value="2147483647" />
            </xs:restriction>
          </xs:simpleType>
        </xs:element>
        <xs:element name="penerimaan" msprop:Generator_ColumnVarNameInTable="columnpenerimaan" msprop:Generator_ColumnPropNameInRow="penerimaan" msprop:Generator_ColumnPropNameInTable="penerimaanColumn" msprop:Generator_UserColumnName="penerimaan" type="xs:long" minOccurs="0" />
        <xs:element name="pengeluaran" msprop:Generator_ColumnVarNameInTable="columnpengeluaran" msprop:Generator_ColumnPropNameInRow="pengeluaran" msprop:Generator_ColumnPropNameInTable="pengeluaranColumn" msprop:Generator_UserColumnName="pengeluaran" type="xs:long" minOccurs="0" />
        <xs:element name="sort_order" msprop:Generator_ColumnVarNameInTable="columnsort_order" msprop:Generator_ColumnPropNameInRow="sort_order" msprop:Generator_ColumnPropNameInTable="sort_orderColumn" msprop:Generator_UserColumnName="sort_order" type="xs:long" minOccurs="0" />
        <xs:element name="kode" msprop:Generator_ColumnVarNameInTable="columnkode" msprop:Generator_ColumnPropNameInRow="kode" msprop:Generator_ColumnPropNameInTable="kodeColumn" msprop:Generator_UserColumnName="kode">
          <xs:simpleType>
            <xs:restriction base="xs:string">
              <xs:maxLength value="2147483647" />
            </xs:restriction>
          </xs:simpleType>
        </xs:element>
        <xs:element name="parent_id" msprop:Generator_ColumnVarNameInTable="columnparent_id" msprop:Generator_ColumnPropNameInRow="parent_id" msprop:Generator_ColumnPropNameInTable="parent_idColumn" msprop:Generator_UserColumnName="parent_id" type="xs:long" minOccurs="0" />
      </xs:sequence>
    </xs:complexType>
  </xs:element>
  <xs:element name="SqliteDataManager" msdata:IsDataSet="true" msdata:Locale="en-US" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="SqliteDataManager" msprop:Generator_UserDSName="SqliteDataManager">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element ref="BukuKasUmum" />
        <xs:element name="LaporanBulanan" msprop:Generator_TableClassName="LaporanBulananDataTable" msprop:Generator_TableVarName="tableLaporanBulanan" msprop:Generator_TablePropName="LaporanBulanan" msprop:Generator_RowDeletingName="LaporanBulananRowDeleting" msprop:Generator_RowChangingName="LaporanBulananRowChanging" msprop:Generator_RowEvHandlerName="LaporanBulananRowChangeEventHandler" msprop:Generator_RowDeletedName="LaporanBulananRowDeleted" msprop:Generator_UserTableName="LaporanBulanan" msprop:Generator_RowChangedName="LaporanBulananRowChanged" msprop:Generator_RowEvArgName="LaporanBulananRowChangeEvent" msprop:Generator_RowClassName="LaporanBulananRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:long" />
              <xs:element name="bulan" msprop:Generator_ColumnVarNameInTable="columnbulan" msprop:Generator_ColumnPropNameInRow="bulan" msprop:Generator_ColumnPropNameInTable="bulanColumn" msprop:Generator_UserColumnName="bulan" type="xs:long" />
              <xs:element name="tahun" msprop:Generator_ColumnVarNameInTable="columntahun" msprop:Generator_ColumnPropNameInRow="tahun" msprop:Generator_ColumnPropNameInTable="tahunColumn" msprop:Generator_UserColumnName="tahun" type="xs:long" />
              <xs:element name="no" msprop:Generator_ColumnVarNameInTable="columnno" msprop:Generator_ColumnPropNameInRow="no" msprop:Generator_ColumnPropNameInTable="noColumn" msprop:Generator_UserColumnName="no" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="uraian_penerimaan" msprop:Generator_ColumnVarNameInTable="columnuraian_penerimaan" msprop:Generator_ColumnPropNameInRow="uraian_penerimaan" msprop:Generator_ColumnPropNameInTable="uraian_penerimaanColumn" msprop:Generator_UserColumnName="uraian_penerimaan" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="beban_pk_penerimaan" msprop:Generator_ColumnVarNameInTable="columnbeban_pk_penerimaan" msprop:Generator_ColumnPropNameInRow="beban_pk_penerimaan" msprop:Generator_ColumnPropNameInTable="beban_pk_penerimaanColumn" msprop:Generator_UserColumnName="beban_pk_penerimaan" type="xs:long" minOccurs="0" />
              <xs:element name="jumlah_penerimaan" msprop:Generator_ColumnVarNameInTable="columnjumlah_penerimaan" msprop:Generator_ColumnPropNameInRow="jumlah_penerimaan" msprop:Generator_ColumnPropNameInTable="jumlah_penerimaanColumn" msprop:Generator_UserColumnName="jumlah_penerimaan" type="xs:long" minOccurs="0" />
              <xs:element name="uraian_pengeluaran" msprop:Generator_ColumnVarNameInTable="columnuraian_pengeluaran" msprop:Generator_ColumnPropNameInRow="uraian_pengeluaran" msprop:Generator_ColumnPropNameInTable="uraian_pengeluaranColumn" msprop:Generator_UserColumnName="uraian_pengeluaran" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="beban_pk_pengeluaran" msprop:Generator_ColumnVarNameInTable="columnbeban_pk_pengeluaran" msprop:Generator_ColumnPropNameInRow="beban_pk_pengeluaran" msprop:Generator_ColumnPropNameInTable="beban_pk_pengeluaranColumn" msprop:Generator_UserColumnName="beban_pk_pengeluaran" type="xs:long" minOccurs="0" />
              <xs:element name="jumlah_pengeluaran" msprop:Generator_ColumnVarNameInTable="columnjumlah_pengeluaran" msprop:Generator_ColumnPropNameInRow="jumlah_pengeluaran" msprop:Generator_ColumnPropNameInTable="jumlah_pengeluaranColumn" msprop:Generator_UserColumnName="jumlah_pengeluaran" type="xs:long" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="LaporanSemester" msprop:Generator_TableClassName="LaporanSemesterDataTable" msprop:Generator_TableVarName="tableLaporanSemester" msprop:Generator_TablePropName="LaporanSemester" msprop:Generator_RowDeletingName="LaporanSemesterRowDeleting" msprop:Generator_RowChangingName="LaporanSemesterRowChanging" msprop:Generator_RowEvHandlerName="LaporanSemesterRowChangeEventHandler" msprop:Generator_RowDeletedName="LaporanSemesterRowDeleted" msprop:Generator_UserTableName="LaporanSemester" msprop:Generator_RowChangedName="LaporanSemesterRowChanged" msprop:Generator_RowEvArgName="LaporanSemesterRowChangeEvent" msprop:Generator_RowClassName="LaporanSemesterRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:long" />
              <xs:element name="semester" msprop:Generator_ColumnVarNameInTable="columnsemester" msprop:Generator_ColumnPropNameInRow="semester" msprop:Generator_ColumnPropNameInTable="semesterColumn" msprop:Generator_UserColumnName="semester" type="xs:long" />
              <xs:element name="tahun" msprop:Generator_ColumnVarNameInTable="columntahun" msprop:Generator_ColumnPropNameInRow="tahun" msprop:Generator_ColumnPropNameInTable="tahunColumn" msprop:Generator_UserColumnName="tahun" type="xs:long" />
              <xs:element name="no" msprop:Generator_ColumnVarNameInTable="columnno" msprop:Generator_ColumnPropNameInRow="no" msprop:Generator_ColumnPropNameInTable="noColumn" msprop:Generator_UserColumnName="no" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="uraian" msprop:Generator_ColumnVarNameInTable="columnuraian" msprop:Generator_ColumnPropNameInRow="uraian" msprop:Generator_ColumnPropNameInTable="uraianColumn" msprop:Generator_UserColumnName="uraian" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="prosentase_anggaran" msprop:Generator_ColumnVarNameInTable="columnprosentase_anggaran" msprop:Generator_ColumnPropNameInRow="prosentase_anggaran" msprop:Generator_ColumnPropNameInTable="prosentase_anggaranColumn" msprop:Generator_UserColumnName="prosentase_anggaran" type="xs:double" minOccurs="0" />
              <xs:element name="jumlah_anggaran" msprop:Generator_ColumnVarNameInTable="columnjumlah_anggaran" msprop:Generator_ColumnPropNameInRow="jumlah_anggaran" msprop:Generator_ColumnPropNameInTable="jumlah_anggaranColumn" msprop:Generator_UserColumnName="jumlah_anggaran" type="xs:long" minOccurs="0" />
              <xs:element name="realisasi_anggaran_1" msprop:Generator_ColumnVarNameInTable="columnrealisasi_anggaran_1" msprop:Generator_ColumnPropNameInRow="realisasi_anggaran_1" msprop:Generator_ColumnPropNameInTable="realisasi_anggaran_1Column" msprop:Generator_UserColumnName="realisasi_anggaran_1" type="xs:long" minOccurs="0" />
              <xs:element name="realisasi_anggaran_2" msprop:Generator_ColumnVarNameInTable="columnrealisasi_anggaran_2" msprop:Generator_ColumnPropNameInRow="realisasi_anggaran_2" msprop:Generator_ColumnPropNameInTable="realisasi_anggaran_2Column" msprop:Generator_UserColumnName="realisasi_anggaran_2" type="xs:long" minOccurs="0" />
              <xs:element name="realisasi_anggaran_3" msprop:Generator_ColumnVarNameInTable="columnrealisasi_anggaran_3" msprop:Generator_ColumnPropNameInRow="realisasi_anggaran_3" msprop:Generator_ColumnPropNameInTable="realisasi_anggaran_3Column" msprop:Generator_UserColumnName="realisasi_anggaran_3" type="xs:long" minOccurs="0" />
              <xs:element name="realisasi_anggaran_4" msprop:Generator_ColumnVarNameInTable="columnrealisasi_anggaran_4" msprop:Generator_ColumnPropNameInRow="realisasi_anggaran_4" msprop:Generator_ColumnPropNameInTable="realisasi_anggaran_4Column" msprop:Generator_UserColumnName="realisasi_anggaran_4" type="xs:long" minOccurs="0" />
              <xs:element name="jumlah_realisasi" msprop:Generator_ColumnVarNameInTable="columnjumlah_realisasi" msprop:Generator_ColumnPropNameInRow="jumlah_realisasi" msprop:Generator_ColumnPropNameInTable="jumlah_realisasiColumn" msprop:Generator_UserColumnName="jumlah_realisasi" type="xs:long" minOccurs="0" />
              <xs:element name="prosentase_pajak" msprop:Generator_ColumnVarNameInTable="columnprosentase_pajak" msprop:Generator_ColumnPropNameInRow="prosentase_pajak" msprop:Generator_ColumnPropNameInTable="prosentase_pajakColumn" msprop:Generator_UserColumnName="prosentase_pajak" type="xs:double" minOccurs="0" />
              <xs:element name="pajak_yang_diterima" msprop:Generator_ColumnVarNameInTable="columnpajak_yang_diterima" msprop:Generator_ColumnPropNameInRow="pajak_yang_diterima" msprop:Generator_ColumnPropNameInTable="pajak_yang_diterimaColumn" msprop:Generator_UserColumnName="pajak_yang_diterima" type="xs:long" minOccurs="0" />
              <xs:element name="pajak_yang_disetorkan" msprop:Generator_ColumnVarNameInTable="columnpajak_yang_disetorkan" msprop:Generator_ColumnPropNameInRow="pajak_yang_disetorkan" msprop:Generator_ColumnPropNameInTable="pajak_yang_disetorkanColumn" msprop:Generator_UserColumnName="pajak_yang_disetorkan" type="xs:long" minOccurs="0" />
              <xs:element name="sisa_dana" msprop:Generator_ColumnVarNameInTable="columnsisa_dana" msprop:Generator_ColumnPropNameInRow="sisa_dana" msprop:Generator_ColumnPropNameInTable="sisa_danaColumn" msprop:Generator_UserColumnName="sisa_dana" type="xs:long" minOccurs="0" />
              <xs:element name="keterangan" msprop:Generator_ColumnVarNameInTable="columnketerangan" msprop:Generator_ColumnPropNameInRow="keterangan" msprop:Generator_ColumnPropNameInTable="keteranganColumn" msprop:Generator_UserColumnName="keterangan" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="LaporanTriwulan" msprop:Generator_TableClassName="LaporanTriwulanDataTable" msprop:Generator_TableVarName="tableLaporanTriwulan" msprop:Generator_TablePropName="LaporanTriwulan" msprop:Generator_RowDeletingName="LaporanTriwulanRowDeleting" msprop:Generator_RowChangingName="LaporanTriwulanRowChanging" msprop:Generator_RowEvHandlerName="LaporanTriwulanRowChangeEventHandler" msprop:Generator_RowDeletedName="LaporanTriwulanRowDeleted" msprop:Generator_UserTableName="LaporanTriwulan" msprop:Generator_RowChangedName="LaporanTriwulanRowChanged" msprop:Generator_RowEvArgName="LaporanTriwulanRowChangeEvent" msprop:Generator_RowClassName="LaporanTriwulanRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:long" />
              <xs:element name="triwulan" msprop:Generator_ColumnVarNameInTable="columntriwulan" msprop:Generator_ColumnPropNameInRow="triwulan" msprop:Generator_ColumnPropNameInTable="triwulanColumn" msprop:Generator_UserColumnName="triwulan" type="xs:long" />
              <xs:element name="tahun" msprop:Generator_ColumnVarNameInTable="columntahun" msprop:Generator_ColumnPropNameInRow="tahun" msprop:Generator_ColumnPropNameInTable="tahunColumn" msprop:Generator_UserColumnName="tahun" type="xs:long" />
              <xs:element name="no" msprop:Generator_ColumnVarNameInTable="columnno" msprop:Generator_ColumnPropNameInRow="no" msprop:Generator_ColumnPropNameInTable="noColumn" msprop:Generator_UserColumnName="no" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="uraian" msprop:Generator_ColumnVarNameInTable="columnuraian" msprop:Generator_ColumnPropNameInRow="uraian" msprop:Generator_ColumnPropNameInTable="uraianColumn" msprop:Generator_UserColumnName="uraian" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="prosentase_anggaran" msprop:Generator_ColumnVarNameInTable="columnprosentase_anggaran" msprop:Generator_ColumnPropNameInRow="prosentase_anggaran" msprop:Generator_ColumnPropNameInTable="prosentase_anggaranColumn" msprop:Generator_UserColumnName="prosentase_anggaran" type="xs:double" minOccurs="0" />
              <xs:element name="jumlah_anggaran" msprop:Generator_ColumnVarNameInTable="columnjumlah_anggaran" msprop:Generator_ColumnPropNameInRow="jumlah_anggaran" msprop:Generator_ColumnPropNameInTable="jumlah_anggaranColumn" msprop:Generator_UserColumnName="jumlah_anggaran" type="xs:long" minOccurs="0" />
              <xs:element name="jumlah_realisasi" msprop:Generator_ColumnVarNameInTable="columnjumlah_realisasi" msprop:Generator_ColumnPropNameInRow="jumlah_realisasi" msprop:Generator_ColumnPropNameInTable="jumlah_realisasiColumn" msprop:Generator_UserColumnName="jumlah_realisasi" type="xs:long" minOccurs="0" />
              <xs:element name="prosentase_pajak" msprop:Generator_ColumnVarNameInTable="columnprosentase_pajak" msprop:Generator_ColumnPropNameInRow="prosentase_pajak" msprop:Generator_ColumnPropNameInTable="prosentase_pajakColumn" msprop:Generator_UserColumnName="prosentase_pajak" type="xs:double" minOccurs="0" />
              <xs:element name="pajak_yang_diterima" msprop:Generator_ColumnVarNameInTable="columnpajak_yang_diterima" msprop:Generator_ColumnPropNameInRow="pajak_yang_diterima" msprop:Generator_ColumnPropNameInTable="pajak_yang_diterimaColumn" msprop:Generator_UserColumnName="pajak_yang_diterima" type="xs:long" minOccurs="0" />
              <xs:element name="pajak_yang_disetorkan" msprop:Generator_ColumnVarNameInTable="columnpajak_yang_disetorkan" msprop:Generator_ColumnPropNameInRow="pajak_yang_disetorkan" msprop:Generator_ColumnPropNameInTable="pajak_yang_disetorkanColumn" msprop:Generator_UserColumnName="pajak_yang_disetorkan" type="xs:long" minOccurs="0" />
              <xs:element name="sisa_dana" msprop:Generator_ColumnVarNameInTable="columnsisa_dana" msprop:Generator_ColumnPropNameInRow="sisa_dana" msprop:Generator_ColumnPropNameInTable="sisa_danaColumn" msprop:Generator_UserColumnName="sisa_dana" type="xs:long" minOccurs="0" />
              <xs:element name="keterangan" msprop:Generator_ColumnVarNameInTable="columnketerangan" msprop:Generator_ColumnPropNameInRow="keterangan" msprop:Generator_ColumnPropNameInTable="keteranganColumn" msprop:Generator_UserColumnName="keterangan" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Profil" msprop:Generator_TableClassName="ProfilDataTable" msprop:Generator_TableVarName="tableProfil" msprop:Generator_TablePropName="Profil" msprop:Generator_RowDeletingName="ProfilRowDeleting" msprop:Generator_RowChangingName="ProfilRowChanging" msprop:Generator_RowEvHandlerName="ProfilRowChangeEventHandler" msprop:Generator_RowDeletedName="ProfilRowDeleted" msprop:Generator_UserTableName="Profil" msprop:Generator_RowChangedName="ProfilRowChanged" msprop:Generator_RowEvArgName="ProfilRowChangeEvent" msprop:Generator_RowClassName="ProfilRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:long" />
              <xs:element name="yayasan" msprop:Generator_ColumnVarNameInTable="columnyayasan" msprop:Generator_ColumnPropNameInRow="yayasan" msprop:Generator_ColumnPropNameInTable="yayasanColumn" msprop:Generator_UserColumnName="yayasan" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ketua_yayasan" msprop:Generator_ColumnVarNameInTable="columnketua_yayasan" msprop:Generator_ColumnPropNameInRow="ketua_yayasan" msprop:Generator_ColumnPropNameInTable="ketua_yayasanColumn" msprop:Generator_UserColumnName="ketua_yayasan" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sekolah" msprop:Generator_ColumnVarNameInTable="columnsekolah" msprop:Generator_ColumnPropNameInRow="sekolah" msprop:Generator_ColumnPropNameInTable="sekolahColumn" msprop:Generator_UserColumnName="sekolah" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="kepala_sekolah" msprop:Generator_ColumnVarNameInTable="columnkepala_sekolah" msprop:Generator_ColumnPropNameInRow="kepala_sekolah" msprop:Generator_ColumnPropNameInTable="kepala_sekolahColumn" msprop:Generator_UserColumnName="kepala_sekolah" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="bendahara_sekolah" msprop:Generator_ColumnVarNameInTable="columnbendahara_sekolah" msprop:Generator_ColumnPropNameInRow="bendahara_sekolah" msprop:Generator_ColumnPropNameInTable="bendahara_sekolahColumn" msprop:Generator_UserColumnName="bendahara_sekolah" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="UraianPenggunaan" msprop:Generator_TableClassName="UraianPenggunaanDataTable" msprop:Generator_TableVarName="tableUraianPenggunaan" msprop:Generator_TablePropName="UraianPenggunaan" msprop:Generator_RowDeletingName="UraianPenggunaanRowDeleting" msprop:Generator_RowChangingName="UraianPenggunaanRowChanging" msprop:Generator_RowEvHandlerName="UraianPenggunaanRowChangeEventHandler" msprop:Generator_RowDeletedName="UraianPenggunaanRowDeleted" msprop:Generator_UserTableName="UraianPenggunaan" msprop:Generator_RowChangedName="UraianPenggunaanRowChanged" msprop:Generator_RowEvArgName="UraianPenggunaanRowChangeEvent" msprop:Generator_RowClassName="UraianPenggunaanRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:long" />
              <xs:element name="kode_rekening" msprop:Generator_ColumnVarNameInTable="columnkode_rekening" msprop:Generator_ColumnPropNameInRow="kode_rekening" msprop:Generator_ColumnPropNameInTable="kode_rekeningColumn" msprop:Generator_UserColumnName="kode_rekening" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="uraian" msprop:Generator_ColumnVarNameInTable="columnuraian" msprop:Generator_ColumnPropNameInRow="uraian" msprop:Generator_ColumnPropNameInTable="uraianColumn" msprop:Generator_UserColumnName="uraian" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="kode" msprop:Generator_ColumnVarNameInTable="columnkode" msprop:Generator_ColumnPropNameInRow="kode" msprop:Generator_ColumnPropNameInTable="kodeColumn" msprop:Generator_UserColumnName="kode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tipe" msprop:Generator_ColumnVarNameInTable="columntipe" msprop:Generator_ColumnPropNameInRow="tipe" msprop:Generator_ColumnPropNameInTable="tipeColumn" msprop:Generator_UserColumnName="tipe" type="xs:long" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ProfilSekolah" msprop:Generator_TableClassName="ProfilSekolahDataTable" msprop:Generator_TableVarName="tableProfilSekolah" msprop:Generator_RowChangedName="ProfilSekolahRowChanged" msprop:Generator_TablePropName="ProfilSekolah" msprop:Generator_RowDeletingName="ProfilSekolahRowDeleting" msprop:Generator_RowChangingName="ProfilSekolahRowChanging" msprop:Generator_RowEvHandlerName="ProfilSekolahRowChangeEventHandler" msprop:Generator_RowDeletedName="ProfilSekolahRowDeleted" msprop:Generator_RowClassName="ProfilSekolahRow" msprop:Generator_UserTableName="ProfilSekolah" msprop:Generator_RowEvArgName="ProfilSekolahRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:long" />
              <xs:element name="yayasan" msprop:Generator_ColumnVarNameInTable="columnyayasan" msprop:Generator_ColumnPropNameInRow="yayasan" msprop:Generator_ColumnPropNameInTable="yayasanColumn" msprop:Generator_UserColumnName="yayasan" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ketua_yayasan" msprop:Generator_ColumnVarNameInTable="columnketua_yayasan" msprop:Generator_ColumnPropNameInRow="ketua_yayasan" msprop:Generator_ColumnPropNameInTable="ketua_yayasanColumn" msprop:Generator_UserColumnName="ketua_yayasan" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sekolah" msprop:Generator_ColumnVarNameInTable="columnsekolah" msprop:Generator_ColumnPropNameInRow="sekolah" msprop:Generator_ColumnPropNameInTable="sekolahColumn" msprop:Generator_UserColumnName="sekolah" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="kepala_sekolah" msprop:Generator_ColumnVarNameInTable="columnkepala_sekolah" msprop:Generator_ColumnPropNameInRow="kepala_sekolah" msprop:Generator_ColumnPropNameInTable="kepala_sekolahColumn" msprop:Generator_UserColumnName="kepala_sekolah" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="bendahara_sekolah" msprop:Generator_ColumnVarNameInTable="columnbendahara_sekolah" msprop:Generator_ColumnPropNameInRow="bendahara_sekolah" msprop:Generator_ColumnPropNameInTable="bendahara_sekolahColumn" msprop:Generator_UserColumnName="bendahara_sekolah" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Activation" msprop:Generator_TableClassName="ActivationDataTable" msprop:Generator_TableVarName="tableActivation" msprop:Generator_RowChangedName="ActivationRowChanged" msprop:Generator_TablePropName="Activation" msprop:Generator_RowDeletingName="ActivationRowDeleting" msprop:Generator_RowChangingName="ActivationRowChanging" msprop:Generator_RowEvHandlerName="ActivationRowChangeEventHandler" msprop:Generator_RowDeletedName="ActivationRowDeleted" msprop:Generator_RowClassName="ActivationRow" msprop:Generator_UserTableName="Activation" msprop:Generator_RowEvArgName="ActivationRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="product_number" msprop:Generator_ColumnVarNameInTable="columnproduct_number" msprop:Generator_ColumnPropNameInRow="product_number" msprop:Generator_ColumnPropNameInTable="product_numberColumn" msprop:Generator_UserColumnName="product_number" type="xs:decimal" />
              <xs:element name="activation_code" msprop:Generator_ColumnVarNameInTable="columnactivation_code" msprop:Generator_ColumnPropNameInRow="activation_code" msprop:Generator_ColumnPropNameInTable="activation_codeColumn" msprop:Generator_UserColumnName="activation_code" type="xs:decimal" minOccurs="0" />
              <xs:element name="valid" msprop:Generator_ColumnVarNameInTable="columnvalid" msprop:Generator_ColumnPropNameInRow="valid" msprop:Generator_ColumnPropNameInTable="validColumn" msprop:Generator_UserColumnName="valid" type="xs:boolean" minOccurs="0" />
              <xs:element name="mac_address" msprop:Generator_ColumnVarNameInTable="columnmac_address" msprop:Generator_ColumnPropNameInRow="mac_address" msprop:Generator_ColumnPropNameInTable="mac_addressColumn" msprop:Generator_UserColumnName="mac_address" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:BukuKasUmum" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="LaporanBulanan_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:LaporanBulanan" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="LaporanSemester_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:LaporanSemester" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="LaporanTriwulan_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:LaporanTriwulan" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="Profil_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Profil" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="UraianPenggunaan_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:UraianPenggunaan" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="ProfilSekolah_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ProfilSekolah" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="Activation_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Activation" />
      <xs:field xpath="mstns:product_number" />
    </xs:unique>
  </xs:element>
</xs:schema>